Release 10.1A: OpenEdge Development:
Internationalizing Applications

Using PROUTIL to perform the scan

When you are considering a particular code-page conversion, you want to check an existing database for characters that do not appear in the target code page. This is precisely what is done by the PROUTIL utility with the CONVCHAR CHARSCAN qualifier. It searches for every occurrence of specified characters in every CHARACTER field in the database, using the code page associated with the database. It reports the total number of matched fields, and for each matched field, reports the table name, field name, and record id.

The syntax is:

Syntax

proutil db-name -C convchar charscan target-code-page "character-list" -cpinternal internal-code-page -cpstream stream-code-page

db-name

The database to be converted.

target-codepage

The code page you are considering converting to.

character-list

A list of characters. The character list consists of code-page positions separated by commas. The string can include decimal or hexadecimal values for up to ten characters.

Note: For the complete syntax of the PROUTIL utility, see OpenEdge Data Management: Database Administration .

Here are some examples of scanning databases for character conflicts:

You have an ISO8859-1 database called mydb that you are thinking of converting to 1252. To scan this database for the presence of characters not in 1252, run the following command:

proutil mydb -C convchar charscan 1252 "128,138,140,142,154,156,158,159"

You have an IBM437 database called mydb that you are thinking of converting to ISO8859-15. To scan this database for the presence of characters not in ISO8859-15, run the following command:

proutil mydb -C convchar charscan ISO8859-15 "206,207,209,215,217,172,171,219"